USE [master]
GO
/****** Object:  Database [POS]    Script Date: 2014/01/17 10:57:31 AM ******/
CREATE DATABASE [POS]
 CONTAINMENT = NONE
 ON  PRIMARY 
  Change this path if the folders do not exist on your machine  
( NAME = N'POS', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.JSDEV\MSSQL\DATA\POS.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'POS_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL11.JSDEV\MSSQL\DATA\POS_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [POS] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [POS].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [POS] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [POS] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [POS] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [POS] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [POS] SET ARITHABORT OFF 
GO
ALTER DATABASE [POS] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [POS] SET AUTO_CREATE_STATISTICS ON 
GO
ALTER DATABASE [POS] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [POS] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [POS] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [POS] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [POS] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [POS] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [POS] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [POS] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [POS] SET  DISABLE_BROKER 
GO
ALTER DATABASE [POS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [POS] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [POS] SET TRUSTWORTHY OFF 
GO
ALTER DATABASE [POS] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO
ALTER DATABASE [POS] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [POS] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [POS] SET HONOR_BROKER_PRIORITY OFF 
GO
ALTER DATABASE [POS] SET RECOVERY FULL 
GO
ALTER DATABASE [POS] SET  MULTI_USER 
GO
ALTER DATABASE [POS] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [POS] SET DB_CHAINING OFF 
GO
ALTER DATABASE [POS] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO
ALTER DATABASE [POS] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO
EXEC sys.sp_db_vardecimal_storage_format N'POS', N'ON'
GO
USE [POS]
GO
/****** Object:  Table [dbo].[DrinkOrder]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DrinkOrder](
	[DrinkOrderId] [int] IDENTITY(1,1) NOT NULL,
	[TableOrderId] [int] NOT NULL,
	[DrinkId] [int] NOT NULL,
	[Quantity] [int] NOT NULL,
	[Note] [nvarchar](50) NULL,
	[IsDeleted] [bit] NOT NULL,
	[Created] [datetime] NULL,
 CONSTRAINT [PK_DrinksOrder] PRIMARY KEY CLUSTERED 
(
	[DrinkOrderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Drinks]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Drinks](
	[DrinkId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Unit] [nvarchar](50) NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[Created] [datetime] NULL,
 CONSTRAINT [PK_Drinks] PRIMARY KEY CLUSTERED 
(
	[DrinkId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Food]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Food](
	[FoodId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[FoodTypeId] [int] NULL,
	[Price] [decimal](18, 2) NULL,
	[Unit] [nvarchar](50) NULL,
	[Created] [datetime] NULL,
 CONSTRAINT [PK_Food] PRIMARY KEY CLUSTERED 
(
	[FoodId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FoodOrder]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FoodOrder](
	[FoodOrderId] [int] IDENTITY(1,1) NOT NULL,
	[TableOrderId] [int] NULL,
	[FoodId] [int] NULL,
	[Quantity] [int] NULL,
	[Note] [nvarchar](50) NULL,
	[IsDeleted] [bit] NOT NULL,
	[Created] [datetime] NULL,
 CONSTRAINT [PK_FoodOrder] PRIMARY KEY CLUSTERED 
(
	[FoodOrderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FoodType]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FoodType](
	[FoodTypeId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Created] [datetime] NULL,
 CONSTRAINT [PK_FoodType] PRIMARY KEY CLUSTERED 
(
	[FoodTypeId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TableOrder]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TableOrder](
	[TableOrderId] [int] IDENTITY(1,1) NOT NULL,
	[TableNumber] [nchar](10) NULL,
	[WaiterId] [int] NULL,
	[IsDeleted] [bit] NULL,
	[Created] [datetime] NULL,
 CONSTRAINT [PK_TableOrder] PRIMARY KEY CLUSTERED 
(
	[TableOrderId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  View [dbo].[vDrinkOrders]    Script Date: 2014/01/17 10:57:31 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[vDrinkOrders]
AS
SELECT        dbo.DrinkOrder.DrinkOrderId, dbo.DrinkOrder.TableOrderId, dbo.DrinkOrder.Quantity, dbo.DrinkOrder.IsDeleted, dbo.DrinkOrder.Note, dbo.Drinks.Name, 
                         dbo.Drinks.Unit, dbo.Drinks.Price, dbo.TableOrder.WaiterId, dbo.TableOrder.TableNumber, dbo.DrinkOrder.Created, dbo.Drinks.DrinkId
FROM            dbo.DrinkOrder INNER JOIN
                         dbo.Drinks ON dbo.DrinkOrder.DrinkId = dbo.Drinks.DrinkId INNER JOIN
                         dbo.TableOrder ON dbo.DrinkOrder.TableOrderId = dbo.TableOrder.TableOrderId

GO
SET IDENTITY_INSERT [dbo].[DrinkOrder] ON 

GO
INSERT [dbo].[DrinkOrder] ([DrinkOrderId], [TableOrderId], [DrinkId], [Quantity], [Note], [IsDeleted], [Created]) VALUES (1, 1, 1, 2, N'coke, sprite', 0, CAST(0x0000A2AF00EB9A4A AS DateTime))
GO
INSERT [dbo].[DrinkOrder] ([DrinkOrderId], [TableOrderId], [DrinkId], [Quantity], [Note], [IsDeleted], [Created]) VALUES (2, 1, 3, 1, N'strawberry', 0, CAST(0x0000A2AF00EB9A4A AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[DrinkOrder] OFF
GO
SET IDENTITY_INSERT [dbo].[Drinks] ON 

GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (1, N'Soda Drink', N'Can', CAST(12.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (2, N'Soda Juice', N'Can', CAST(18.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (3, N'Juice', N'Glass', CAST(14.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (4, N'Coffee', N'Cup', CAST(12.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (5, N'Tea', N'Cup', CAST(12.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (6, N'Beer', N'375ml', CAST(18.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (7, N'Cider', N'360ml', CAST(20.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (8, N'White Wine', N'Glass', CAST(28.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (9, N'Red Wine', N'Glass', CAST(31.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (10, N'Clear Liquer', N'1 Tot', CAST(30.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
INSERT [dbo].[Drinks] ([DrinkId], [Name], [Unit], [Price], [Created]) VALUES (11, N'Soda Mixer', N'200ml Can', CAST(15.00 AS Decimal(18, 2)), CAST(0x0000A2AF00EBA516 AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[Drinks] OFF
GO
SET IDENTITY_INSERT [dbo].[Food] ON 

GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (1, N'Burger', 2, CAST(29.00 AS Decimal(18, 2)), N'Meal', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (2, N'Chips Small', 3, CAST(12.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (3, N'Steamed mussels', 1, CAST(33.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (4, N'Pasta Alfredo', 2, CAST(59.90 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (5, N'200g Fillet', 2, CAST(115.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (6, N'500g T-Bone', 2, CAST(125.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (7, N'Mushroom Sauce', 6, CAST(21.00 AS Decimal(18, 2)), N'Bowl', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (8, N'Ceasar Salad', 4, CAST(45.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (9, N'Baked Potato', 3, CAST(32.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (10, N'Choc Brownie', 5, CAST(42.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (11, N'Tiramisu', 5, CAST(38.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
INSERT [dbo].[Food] ([FoodId], [Name], [FoodTypeId], [Price], [Unit], [Created]) VALUES (12, N'Focaccia', 1, CAST(19.00 AS Decimal(18, 2)), N'Plate', CAST(0x0000A2AF00EBAB5A AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[Food] OFF
GO
SET IDENTITY_INSERT [dbo].[FoodOrder] ON 

GO
INSERT [dbo].[FoodOrder] ([FoodOrderId], [TableOrderId], [FoodId], [Quantity], [Note], [IsDeleted], [Created]) VALUES (1, 1, 8, 1, NULL, 0, CAST(0x0000A2AF00EBB171 AS DateTime))
GO
INSERT [dbo].[FoodOrder] ([FoodOrderId], [TableOrderId], [FoodId], [Quantity], [Note], [IsDeleted], [Created]) VALUES (2, 1, 5, 1, N'meduim rare', 0, CAST(0x0000A2AF00EBB171 AS DateTime))
GO
INSERT [dbo].[FoodOrder] ([FoodOrderId], [TableOrderId], [FoodId], [Quantity], [Note], [IsDeleted], [Created]) VALUES (3, 1, 4, 1, NULL, 0, CAST(0x0000A2AF00EBB171 AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[FoodOrder] OFF
GO
SET IDENTITY_INSERT [dbo].[FoodType] ON 

GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (1, N'Starter', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (2, N'Main Meal', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (3, N'Side Dish', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (4, N'Salad', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (5, N'Dessert', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (6, N'Sauce', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
INSERT [dbo].[FoodType] ([FoodTypeId], [Name], [Created]) VALUES (7, N'Kiddies', CAST(0x0000A2AF00EBB815 AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[FoodType] OFF
GO
SET IDENTITY_INSERT [dbo].[TableOrder] ON 

GO
INSERT [dbo].[TableOrder] ([TableOrderId], [TableNumber], [WaiterId], [IsDeleted], [Created]) VALUES (1, N'5         ', 1, 0, CAST(0x0000A2AF00EBCB77 AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[TableOrder] OFF
GO
ALTER TABLE [dbo].[DrinkOrder]  WITH CHECK ADD  CONSTRAINT [FK_DrinksOrder_Drinks] FOREIGN KEY([DrinkId])
REFERENCES [dbo].[Drinks] ([DrinkId])
GO
ALTER TABLE [dbo].[DrinkOrder] CHECK CONSTRAINT [FK_DrinksOrder_Drinks]
GO
ALTER TABLE [dbo].[DrinkOrder]  WITH CHECK ADD  CONSTRAINT [FK_DrinksOrder_TableOrder] FOREIGN KEY([TableOrderId])
REFERENCES [dbo].[TableOrder] ([TableOrderId])
GO
ALTER TABLE [dbo].[DrinkOrder] CHECK CONSTRAINT [FK_DrinksOrder_TableOrder]
GO
ALTER TABLE [dbo].[Food]  WITH CHECK ADD  CONSTRAINT [FK_Food_FoodType] FOREIGN KEY([FoodTypeId])
REFERENCES [dbo].[FoodType] ([FoodTypeId])
GO
ALTER TABLE [dbo].[Food] CHECK CONSTRAINT [FK_Food_FoodType]
GO
ALTER TABLE [dbo].[FoodOrder]  WITH CHECK ADD  CONSTRAINT [FK_FoodOrder_Food] FOREIGN KEY([FoodId])
REFERENCES [dbo].[Food] ([FoodId])
GO
ALTER TABLE [dbo].[FoodOrder] CHECK CONSTRAINT [FK_FoodOrder_Food]
GO
ALTER TABLE [dbo].[FoodOrder]  WITH CHECK ADD  CONSTRAINT [FK_FoodOrder_TableOrder] FOREIGN KEY([TableOrderId])
REFERENCES [dbo].[TableOrder] ([TableOrderId])
GO
ALTER TABLE [dbo].[FoodOrder] CHECK CONSTRAINT [FK_FoodOrder_TableOrder]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[33] 4[42] 2[7] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "DrinkOrder"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 260
               Right = 208
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "Drinks"
            Begin Extent = 
               Top = 0
               Left = 453
               Bottom = 319
               Right = 623
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "TableOrder"
            Begin Extent = 
               Top = 6
               Left = 870
               Bottom = 312
               Right = 1040
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDrinkOrders'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'vDrinkOrders'
GO
USE [master]
GO
ALTER DATABASE [POS] SET  READ_WRITE 
GO
